Tabela DocumentType

Definicja tabeli DocumentType

Name

DocumentType

Code

DocumentType

Comment

 


Lista kolumn tabeli DocumentType

Name

Code

DocumentTypeID

DocumentTypeID

Active

Active

Code

Code

FullName

FullName

ShortName

ShortName


Kolumna DocumentTypeID tabeli DocumentType

Definicja kolumny DocumentTypeID tabeli DocumentType

Name

DocumentTypeID

Code

DocumentTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli DocumentType

Definicja kolumny Active tabeli DocumentType

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli DocumentType

Definicja kolumny Code tabeli DocumentType

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli DocumentType

Definicja kolumny FullName tabeli DocumentType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli DocumentType

Definicja kolumny ShortName tabeli DocumentType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Lista kluczy tabeli DocumentType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DocumentType

Definicja klucza Identifier_1 tabeli DocumentType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment